package cn.kimming.wms.domain;

import lombok.Getter;

//订货报表的枚举实例
public enum OrderGroupType {
	EMPLOYEE("订货人员", "obj.bill.inputUser.name", "obj.bill.inputUser"),
	PRODUCT("货品名称", "obj.product.name", "obj.product"),
	BRAND("品牌名称", "obj.product.brand.name", "obj.product.brand"),
	SUPPLIER("货品供应商", "obj.bill.supplier.name", "obj.bill.supplier"),
	MONTH("订货日期(月)", "date_format(obj.bill.vdate,'%Y-%m')", "date_format(obj.bill.vdate,'%Y-%m')"),
	DAY("订货日期(日)", "date_format(obj.bill.vdate,'%Y-%m-%d')", "date_format(obj.bill.vdate,'%Y-%m-%d')");
	
	
	private OrderGroupType(String groupType, String groupField, String groupBy) {
		this.groupType = groupType;
		this.groupField = groupField;
		this.groupBy = groupBy;
	}
	
	@Getter 
	private String groupType;	//分组类型(中文)
	@Getter 
	private String groupField;	//分组的字段,拼接在VO中
	@Getter 
	private String groupBy;	//分组的类型,拼接在GROUP BY 语句后
}
